HubSpot

Adding HubSpot as data source

Prerequisite for adding HubSpot

The following connector information is required from the client:

• Access Token

• Start Date

Do the following:

1. Login to your HubSpot account Hubspot Login

2. Set up Hubspot for Airbyte Open Source: Private app setup (Recommended): If you are authenticating via a Private App, you will need to use your access token to set up the connector. Refer to the official HubSpot documentation for a detailed guide.

3. After private app setup is complete In your HubSpot account, click the settings icon in the main navigation bar.

4. In the left sidebar menu, navigate to Integrations > Private apps.

5. Click the name of your app.

6. Click the Auth tab and then click Show token to reveal your access token.

7. Click Copy to copy the token to your clipboard.

Do the following to add HubSpot as a data source:

1. From the left navigation panel, click Lakehouse and then click Data Sources.

2. From the upper right corner of the page, click the + New Database button to start the process of adding a new database.

3. In the New Data Source page, click the HubSpot icon.

4. Specify the following details to add HubSpot. Once you have connected a data source, the system immediately fetches its schema. After this schema retrieval process is complete you can browse and interact with the tables and data.

   

   Field	Description
   Connection name	Enter a unique name for the connection.
   Access token	Specify the HubSpot access token.
   Start Date	Enter the date in the MM-DD-YYYY format. DataGOL will replicate the data updated on and after this date. If this field is blank, DataGOL will replicate the data for last two years.

5. Click Submit.

Supported sync modes

HubSpot supports the following Sync modes:

• Full Refresh
• Incremental

Supported streams

HubSpot supports the following streams:

Here's your list with all the brackets and their contents removed:

• Campaigns

• Companies

• Contact Lists

• Contacts

• Deal Pipelines

• Deals Records that have been deleted and stored in HubSpot's recycle bin will only be kept for 90 days.

• Deals Archived

• Email Events

• Email Subscriptions

• Engagements

• Engagements Calls

• Engagements Emails

• Engagements Meetings

• Engagements Notes

• Engagements Tasks

• Forms

• Form Submissions

• Goals

• Leads

• Line Items

• Marketing Emails

• Owners

• Owners Archived

• Products

• Contacts Property History

• Companies Property History

• Deals Property History

• Subscription Changes

• Tickets

• Ticket Pipelines

• Workflows

• ContactsWebAnalytics

• CompaniesWebAnalytics

• DealsWebAnalytics

• TicketsWebAnalytics

• EngagementsCallsWebAnalytics

• EngagementsEmailsWebAnalytics

• EngagementsMeetingsWebAnalytics

• EngagementsNotesWebAnalytics

• EngagementsTasksWebAnalytics

• GoalsWebAnalytics

• LineItemsWebAnalytics

• ProductsWebAnalytics